Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 40374 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.4 MiB |
| Average record size in memory | 88.0 B |
Variable types
| Numeric | 7 |
|---|---|
| Text | 2 |
| Categorical | 1 |
| DateTime | 1 |
patient_id has unique values | Unique |
usefulCount has 2185 (5.4%) zeros | Zeros |
Reproduction
| Analysis started | 2024-10-07 11:39:53.067065 |
|---|---|
| Analysis finished | 2024-10-07 11:40:13.920665 |
| Duration | 20.85 seconds |
| Software version | ydata-profiling v4.8.3 |
| Download configuration | config.json |
df_index
Real number (ℝ)
| Distinct | 9941 |
|---|---|
| Distinct (%) | 24.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4951.7208 |
| Minimum | 0 |
|---|---|
| Maximum | 9999 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 315.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 459 |
| Q1 | 2432 |
| median | 4926.5 |
| Q3 | 7478 |
| 95-th percentile | 9487.35 |
| Maximum | 9999 |
| Range | 9999 |
| Interquartile range (IQR) | 5046 |
Descriptive statistics
| Standard deviation | 2903.0755 |
|---|---|
| Coefficient of variation (CV) | 0.58627608 |
| Kurtosis | -1.2061536 |
| Mean | 4951.7208 |
| Median Absolute Deviation (MAD) | 2522.5 |
| Skewness | 0.014328404 |
| Sum | 1.9992078 × 108 |
| Variance | 8427847.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1912 | 10 | < 0.1% |
| 3748 | 10 | < 0.1% |
| 7672 | 9 | < 0.1% |
| 9898 | 9 | < 0.1% |
| 9266 | 9 | < 0.1% |
| 8310 | 9 | < 0.1% |
| 402 | 9 | < 0.1% |
| 1410 | 9 | < 0.1% |
| 5549 | 9 | < 0.1% |
| 4612 | 9 | < 0.1% |
| Other values (9931) | 40282 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1 | 6 | |
| 2 | 7 | |
| 3 | 5 | |
| 4 | 1 | < 0.1% |
| 5 | 5 | |
| 6 | 6 | |
| 7 | 4 | |
| 8 | 6 | |
| 9 | 6 |
| Value | Count | Frequency (%) |
| 9999 | 5 | |
| 9998 | 7 | |
| 9997 | 8 | |
| 9996 | 4 | |
| 9995 | 5 | |
| 9994 | 6 | |
| 9993 | 3 | < 0.1% |
| 9992 | 4 | |
| 9991 | 5 | |
| 9990 | 2 | < 0.1% |
patient_id
Real number (ℝ)
UNIQUE 
| Distinct | 40374 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 119859.19 |
| Minimum | 4 |
|---|---|
| Maximum | 232225 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 315.6 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 16057.65 |
| Q1 | 68247.25 |
| median | 121926 |
| Q3 | 170138 |
| 95-th percentile | 225278.05 |
| Maximum | 232225 |
| Range | 232221 |
| Interquartile range (IQR) | 101890.75 |
Descriptive statistics
| Standard deviation | 64031.27 |
|---|---|
| Coefficient of variation (CV) | 0.53422077 |
| Kurtosis | -1.0402521 |
| Mean | 119859.19 |
| Median Absolute Deviation (MAD) | 50309 |
| Skewness | -0.0060764011 |
| Sum | 4.8391951 × 109 |
| Variance | 4.1000036 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 143975 | 1 | < 0.1% |
| 136915 | 1 | < 0.1% |
| 99463 | 1 | < 0.1% |
| 76597 | 1 | < 0.1% |
| 192533 | 1 | < 0.1% |
| 201062 | 1 | < 0.1% |
| 72299 | 1 | < 0.1% |
| 106639 | 1 | < 0.1% |
| 151484 | 1 | < 0.1% |
| 214353 | 1 | < 0.1% |
| Other values (40364) | 40364 |
| Value | Count | Frequency (%) |
| 4 | 1 | |
| 5 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 | |
| 12 | 1 | |
| 14 | 1 | |
| 16 | 1 | |
| 22 | 1 |
| Value | Count | Frequency (%) |
| 232225 | 1 | |
| 232224 | 1 | |
| 232223 | 1 | |
| 232220 | 1 | |
| 232218 | 1 | |
| 232217 | 1 | |
| 232215 | 1 | |
| 232213 | 1 | |
| 232210 | 1 | |
| 232208 | 1 |
drugName
Text
| Distinct | 59 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 315.6 KiB |
Length
| Max length | 54 |
|---|---|
| Median length | 31 |
| Mean length | 14.606578 |
| Min length | 5 |
Characters and Unicode
| Total characters | 589726 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Etonogestrel |
|---|---|
| 2nd row | Implanon |
| 3rd row | Suprep Bowel Prep Kit |
| 4th row | Escitalopram |
| 5th row | Mirena |
| Value | Count | Frequency (%) |
| 7899 | 11.8% | |
| ethinyl | 6258 | 9.4% |
| estradiol | 6258 | 9.4% |
| levonorgestrel | 4158 | 6.2% |
| etonogestrel | 3075 | 4.6% |
| norethindrone | 2002 | 3.0% |
| nexplanon | 1669 | 2.5% |
| norgestimate | 1501 | 2.2% |
| sulfate | 1431 | 2.1% |
| bupropion | 1395 | 2.1% |
| Other values (59) | 31125 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 70544 | |
| o | 54876 | 9.3% |
| n | 49849 | 8.5% |
| r | 45787 | 7.8% |
| t | 45748 | 7.8% |
| i | 41047 | 7.0% |
| l | 39366 | 6.7% |
| a | 35974 | 6.1% |
| 26397 | 4.5% | |
| s | 23742 | 4.0% |
| Other values (37) | 156396 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 589726 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 70544 | |
| o | 54876 | 9.3% |
| n | 49849 | 8.5% |
| r | 45787 | 7.8% |
| t | 45748 | 7.8% |
| i | 41047 | 7.0% |
| l | 39366 | 6.7% |
| a | 35974 | 6.1% |
| 26397 | 4.5% | |
| s | 23742 | 4.0% |
| Other values (37) | 156396 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 589726 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 70544 | |
| o | 54876 | 9.3% |
| n | 49849 | 8.5% |
| r | 45787 | 7.8% |
| t | 45748 | 7.8% |
| i | 41047 | 7.0% |
| l | 39366 | 6.7% |
| a | 35974 | 6.1% |
| 26397 | 4.5% | |
| s | 23742 | 4.0% |
| Other values (37) | 156396 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 589726 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 70544 | |
| o | 54876 | 9.3% |
| n | 49849 | 8.5% |
| r | 45787 | 7.8% |
| t | 45748 | 7.8% |
| i | 41047 | 7.0% |
| l | 39366 | 6.7% |
| a | 35974 | 6.1% |
| 26397 | 4.5% | |
| s | 23742 | 4.0% |
| Other values (37) | 156396 |
condition
Categorical
| Distinct | 41 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 315.6 KiB |
| birth control | |
|---|---|
| depression | |
| anxiety | |
| weight loss | |
| obesity | |
| Other values (36) |
Length
| Max length | 28 |
|---|---|
| Median length | 27 |
| Mean length | 13.574058 |
| Min length | 4 |
Characters and Unicode
| Total characters | 548039 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | birth control |
|---|---|
| 2nd row | birth control |
| 3rd row | bowel preparation |
| 4th row | depression |
| 5th row | birth control |
Common Values
| Value | Count | Frequency (%) |
| birth control | 16191 | |
| depression | 4002 | 9.9% |
| anxiety | 2006 | 5.0% |
| weight loss | 1974 | 4.9% |
| obesity | 1772 | 4.4% |
| emergency contraception | 1408 | 3.5% |
| vaginal yeast infection | 1264 | 3.1% |
| abnormal uterine bleeding | 1237 | 3.1% |
| smoking cessation | 1134 | 2.8% |
| acne | 1072 | 2.7% |
| Other values (31) | 8314 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| birth | 16191 | |
| control | 16191 | |
| depression | 4002 | 5.4% |
| anxiety | 3510 | 4.7% |
| disorde | 2836 | 3.8% |
| weight | 1974 | 2.6% |
| loss | 1974 | 2.6% |
| obesity | 1772 | 2.4% |
| infection | 1465 | 2.0% |
| emergency | 1408 | 1.9% |
| Other values (50) | 23416 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 57318 | |
| r | 52337 | |
| t | 51982 | |
| i | 51675 | 9.4% |
| n | 46914 | 8.6% |
| e | 43925 | 8.0% |
| 34365 | 6.3% | |
| s | 27985 | 5.1% |
| c | 26253 | 4.8% |
| l | 25685 | 4.7% |
| Other values (18) | 129600 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 548039 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 57318 | |
| r | 52337 | |
| t | 51982 | |
| i | 51675 | 9.4% |
| n | 46914 | 8.6% |
| e | 43925 | 8.0% |
| 34365 | 6.3% | |
| s | 27985 | 5.1% |
| c | 26253 | 4.8% |
| l | 25685 | 4.7% |
| Other values (18) | 129600 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 548039 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 57318 | |
| r | 52337 | |
| t | 51982 | |
| i | 51675 | 9.4% |
| n | 46914 | 8.6% |
| e | 43925 | 8.0% |
| 34365 | 6.3% | |
| s | 27985 | 5.1% |
| c | 26253 | 4.8% |
| l | 25685 | 4.7% |
| Other values (18) | 129600 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 548039 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 57318 | |
| r | 52337 | |
| t | 51982 | |
| i | 51675 | 9.4% |
| n | 46914 | 8.6% |
| e | 43925 | 8.0% |
| 34365 | 6.3% | |
| s | 27985 | 5.1% |
| c | 26253 | 4.8% |
| l | 25685 | 4.7% |
| Other values (18) | 129600 |
rating
Real number (ℝ)
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.8069054 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 315.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 8 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.2706596 |
|---|---|
| Coefficient of variation (CV) | 0.48049141 |
| Kurtosis | -1.0411849 |
| Mean | 6.8069054 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.6894669 |
| Sum | 274822 |
| Variance | 10.697214 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 10 | 11411 | |
| 9 | 6923 | |
| 1 | 5376 | |
| 8 | 4768 | |
| 7 | 2508 | 6.2% |
| 5 | 2342 | 5.8% |
| 2 | 1981 | 4.9% |
| 3 | 1933 | 4.8% |
| 6 | 1665 | 4.1% |
| 4 | 1467 | 3.6% |
| Value | Count | Frequency (%) |
| 1 | 5376 | |
| 2 | 1981 | 4.9% |
| 3 | 1933 | 4.8% |
| 4 | 1467 | 3.6% |
| 5 | 2342 | 5.8% |
| 6 | 1665 | 4.1% |
| 7 | 2508 | 6.2% |
| 8 | 4768 | |
| 9 | 6923 | |
| 10 | 11411 |
| Value | Count | Frequency (%) |
| 10 | 11411 | |
| 9 | 6923 | |
| 8 | 4768 | |
| 7 | 2508 | 6.2% |
| 6 | 1665 | 4.1% |
| 5 | 2342 | 5.8% |
| 4 | 1467 | 3.6% |
| 3 | 1933 | 4.8% |
| 2 | 1981 | 4.9% |
| 1 | 5376 |
date
Date
| Distinct | 3446 |
|---|---|
| Distinct (%) | 8.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 315.6 KiB |
| Minimum | 2008-02-25 00:00:00 |
|---|---|
| Maximum | 2017-12-12 00:00:00 |
Histogram with fixed size bins (bins=50)
usefulCount
Real number (ℝ)
ZEROS 
| Distinct | 328 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.184376 |
| Minimum | 0 |
|---|---|
| Maximum | 1291 |
| Zeros | 2185 |
| Zeros (%) | 5.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 315.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 4 |
| median | 10 |
| Q3 | 27 |
| 95-th percentile | 89 |
| Maximum | 1291 |
| Range | 1291 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 38.562687 |
|---|---|
| Coefficient of variation (CV) | 1.6633049 |
| Kurtosis | 145.04823 |
| Mean | 23.184376 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 7.4244198 |
| Sum | 936046 |
| Variance | 1487.0809 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2 | 2403 | 6.0% |
| 1 | 2305 | 5.7% |
| 3 | 2242 | 5.6% |
| 4 | 2240 | 5.5% |
| 0 | 2185 | 5.4% |
| 5 | 2083 | 5.2% |
| 6 | 1824 | 4.5% |
| 7 | 1592 | 3.9% |
| 8 | 1373 | 3.4% |
| 9 | 1202 | 3.0% |
| Other values (318) | 20925 |
| Value | Count | Frequency (%) |
| 0 | 2185 | |
| 1 | 2305 | |
| 2 | 2403 | |
| 3 | 2242 | |
| 4 | 2240 | |
| 5 | 2083 | |
| 6 | 1824 | |
| 7 | 1592 | |
| 8 | 1373 | |
| 9 | 1202 |
| Value | Count | Frequency (%) |
| 1291 | 2 | |
| 1247 | 2 | |
| 949 | 1 | |
| 796 | 1 | |
| 693 | 1 | |
| 644 | 1 | |
| 621 | 1 | |
| 556 | 2 | |
| 526 | 1 | |
| 505 | 2 |
review_length
Real number (ℝ)
| Distinct | 231 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 102.21288 |
| Minimum | 31 |
|---|---|
| Maximum | 1894 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 315.6 KiB |
Quantile statistics
| Minimum | 31 |
|---|---|
| 5-th percentile | 41 |
| Q1 | 72 |
| median | 106 |
| Q3 | 134 |
| 95-th percentile | 148 |
| Maximum | 1894 |
| Range | 1863 |
| Interquartile range (IQR) | 62 |
Descriptive statistics
| Standard deviation | 38.919325 |
|---|---|
| Coefficient of variation (CV) | 0.3807673 |
| Kurtosis | 138.91524 |
| Mean | 102.21288 |
| Median Absolute Deviation (MAD) | 30 |
| Skewness | 3.7384973 |
| Sum | 4126743 |
| Variance | 1514.7138 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 137 | 684 | 1.7% |
| 140 | 669 | 1.7% |
| 142 | 650 | 1.6% |
| 139 | 647 | 1.6% |
| 141 | 627 | 1.6% |
| 134 | 616 | 1.5% |
| 143 | 605 | 1.5% |
| 138 | 604 | 1.5% |
| 135 | 594 | 1.5% |
| 132 | 589 | 1.5% |
| Other values (221) | 34089 |
| Value | Count | Frequency (%) |
| 31 | 194 | |
| 32 | 170 | |
| 33 | 160 | |
| 34 | 181 | |
| 35 | 180 | |
| 36 | 200 | |
| 37 | 200 | |
| 38 | 203 | |
| 39 | 216 | |
| 40 | 193 |
| Value | Count | Frequency (%) |
| 1894 | 1 | |
| 1107 | 1 | |
| 1103 | 1 | |
| 765 | 1 | |
| 617 | 1 | |
| 566 | 1 | |
| 558 | 2 | |
| 554 | 1 | |
| 532 | 1 | |
| 490 | 1 |
review
Text
| Distinct | 33929 |
|---|---|
| Distinct (%) | 84.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 315.6 KiB |
Length
| Max length | 10433 |
|---|---|
| Median length | 751 |
| Mean length | 537.13437 |
| Min length | 134 |
Characters and Unicode
| Total characters | 21686263 |
|---|---|
| Distinct characters | 103 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 27486 ? |
|---|---|
| Unique (%) | 68.1% |
Sample
| 1st row | "my experience has been somewhat mixed. i have been using implanon now for nearly 14 months and have decided to get it removed because i bleed every day, all day. i would occasionally stain my underwear and my sheets. it didn't start out that way, for the first month i didn't bleed at all, then i had an epic two week period, then everything was irregular, which has basically been my new norm, sadly. i decided to get rid of the implanon because of the endless bleeding. i should mention that the bleeding was usually pretty light, a bit more than spotting but not quite a period either. other than the endless bleeding, i've been pretty side effect free, except for minor acne. i didn't get pregnant on it, so yeah! but...blood, a lot of blood." |
|---|---|
| 2nd row | "this is my second implanon would not recommend at all....first one was okay for the first 2 years until i started bleeding which never stopped when i woke in the morning i would stand up and be absolutely covered in blood it was that bad.....i lost 2 stone in weight my mood swings were all over the place and it affected my relationship. i was advised to have that one removed and another one inserted which i did which i'm into the second year now and it's starting all over again! the only good thing about this is the reliability that your not going to get pregnant if there's ever a chance that you can have a quick fumble in between periods!! it gets me so down i can be off in the morning and on again at night.....so frustrating" |
| 3rd row | "my prep instructions were one 6oz bottle the evening before and one 6oz bottle the morning of the colonoscopy. both times were similar, started working within 20-25 minutes and lasted a couple hours. i mixed with sprite. the review that mentions salty grape cough syrup was spot on. the first bottle wasn't terrible, the second one almost made me puke. compared to other prep experiences i've heard outside of this site i think suprep is probably one of the easier ones, of course everyone reacts different." |
| 4th row | "i felt a positive difference within the first week. i also have generalized anxiety and it seems to have helped with it as well. due to my epilepsy, i take the highest dosage that i can, which is 10mg. i feel better but i think 20 would work great." |
| 5th row | "i have been on mirena for over a year now and have experienced some side effects. side effects to watch out for are severe mood swings, hair loss, depression, acne, dizziness, headaches, memory loss, and insomnia. " |
| Value | Count | Frequency (%) |
| i | 241801 | 5.9% |
| and | 131487 | 3.2% |
| the | 124167 | 3.0% |
| to | 95149 | 2.3% |
| it | 90351 | 2.2% |
| my | 88903 | 2.2% |
| a | 85934 | 2.1% |
| for | 58439 | 1.4% |
| was | 56284 | 1.4% |
| have | 52734 | 1.3% |
| Other values (37242) | 3101497 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4120883 | ||
| e | 1959109 | 9.0% |
| t | 1558629 | 7.2% |
| i | 1403755 | 6.5% |
| a | 1363661 | 6.3% |
| o | 1239702 | 5.7% |
| n | 1159102 | 5.3% |
| s | 994051 | 4.6% |
| r | 861274 | 4.0% |
| d | 743783 | 3.4% |
| Other values (93) | 6282314 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 21686263 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4120883 | ||
| e | 1959109 | 9.0% |
| t | 1558629 | 7.2% |
| i | 1403755 | 6.5% |
| a | 1363661 | 6.3% |
| o | 1239702 | 5.7% |
| n | 1159102 | 5.3% |
| s | 994051 | 4.6% |
| r | 861274 | 4.0% |
| d | 743783 | 3.4% |
| Other values (93) | 6282314 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 21686263 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4120883 | ||
| e | 1959109 | 9.0% |
| t | 1558629 | 7.2% |
| i | 1403755 | 6.5% |
| a | 1363661 | 6.3% |
| o | 1239702 | 5.7% |
| n | 1159102 | 5.3% |
| s | 994051 | 4.6% |
| r | 861274 | 4.0% |
| d | 743783 | 3.4% |
| Other values (93) | 6282314 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 21686263 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4120883 | ||
| e | 1959109 | 9.0% |
| t | 1558629 | 7.2% |
| i | 1403755 | 6.5% |
| a | 1363661 | 6.3% |
| o | 1239702 | 5.7% |
| n | 1159102 | 5.3% |
| s | 994051 | 4.6% |
| r | 861274 | 4.0% |
| d | 743783 | 3.4% |
| Other values (93) | 6282314 |
year
Real number (ℝ)
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2014.5011 |
| Minimum | 2008 |
|---|---|
| Maximum | 2017 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 315.6 KiB |
Quantile statistics
| Minimum | 2008 |
|---|---|
| 5-th percentile | 2009 |
| Q1 | 2013 |
| median | 2015 |
| Q3 | 2016 |
| 95-th percentile | 2017 |
| Maximum | 2017 |
| Range | 9 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.3713601 |
|---|---|
| Coefficient of variation (CV) | 0.0011771451 |
| Kurtosis | 0.053997461 |
| Mean | 2014.5011 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -1.0194117 |
| Sum | 81333468 |
| Variance | 5.6233485 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 2016 | 10128 | |
| 2015 | 8333 | |
| 2017 | 7830 | |
| 2014 | 3079 | 7.6% |
| 2013 | 2705 | 6.7% |
| 2011 | 2465 | 6.1% |
| 2012 | 2140 | 5.3% |
| 2009 | 1609 | 4.0% |
| 2010 | 1544 | 3.8% |
| 2008 | 541 | 1.3% |
| Value | Count | Frequency (%) |
| 2008 | 541 | 1.3% |
| 2009 | 1609 | 4.0% |
| 2010 | 1544 | 3.8% |
| 2011 | 2465 | 6.1% |
| 2012 | 2140 | 5.3% |
| 2013 | 2705 | 6.7% |
| 2014 | 3079 | 7.6% |
| 2015 | 8333 | |
| 2016 | 10128 | |
| 2017 | 7830 |
| Value | Count | Frequency (%) |
| 2017 | 7830 | |
| 2016 | 10128 | |
| 2015 | 8333 | |
| 2014 | 3079 | 7.6% |
| 2013 | 2705 | 6.7% |
| 2012 | 2140 | 5.3% |
| 2011 | 2465 | 6.1% |
| 2010 | 1544 | 3.8% |
| 2009 | 1609 | 4.0% |
| 2008 | 541 | 1.3% |
sentiment
Real number (ℝ)
| Distinct | 18128 |
|---|---|
| Distinct (%) | 44.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.049360133 |
| Minimum | -1 |
|---|---|
| Maximum | 1 |
| Zeros | 357 |
| Zeros (%) | 0.9% |
| Negative | 14162 |
| Negative (%) | 35.1% |
| Memory size | 315.6 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | -0.24401414 |
| Q1 | -0.047367694 |
| median | 0.055238095 |
| Q3 | 0.15555556 |
| 95-th percentile | 0.3203125 |
| Maximum | 1 |
| Range | 2 |
| Interquartile range (IQR) | 0.20292325 |
Descriptive statistics
| Standard deviation | 0.17886839 |
|---|---|
| Coefficient of variation (CV) | 3.6237421 |
| Kurtosis | 2.6139764 |
| Mean | 0.049360133 |
| Median Absolute Deviation (MAD) | 0.10139194 |
| Skewness | -0.3366228 |
| Sum | 1992.866 |
| Variance | 0.0319939 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 357 | 0.9% |
| 0.1 | 164 | 0.4% |
| 0.25 | 154 | 0.4% |
| 0.15 | 122 | 0.3% |
| 0.125 | 117 | 0.3% |
| 0.05 | 105 | 0.3% |
| 0.1666666667 | 102 | 0.3% |
| 0.2 | 102 | 0.3% |
| 0.03333333333 | 98 | 0.2% |
| 0.3 | 98 | 0.2% |
| Other values (18118) | 38955 |
| Value | Count | Frequency (%) |
| -1 | 26 | |
| -0.9765625 | 1 | < 0.1% |
| -0.96875 | 1 | < 0.1% |
| -0.9656612873 | 1 | < 0.1% |
| -0.95 | 2 | < 0.1% |
| -0.9375 | 1 | < 0.1% |
| -0.91 | 1 | < 0.1% |
| -0.9 | 1 | < 0.1% |
| -0.85 | 1 | < 0.1% |
| -0.85 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 12 | |
| 0.925 | 1 | < 0.1% |
| 0.9 | 1 | < 0.1% |
| 0.890625 | 2 | < 0.1% |
| 0.875 | 1 | < 0.1% |
| 0.85 | 1 | < 0.1% |
| 0.8333333333 | 2 | < 0.1% |
| 0.8125 | 1 | < 0.1% |
| 0.805 | 1 | < 0.1% |
| 0.80078125 | 1 | < 0.1% |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| df_index | patient_id | drugName | condition | rating | date | usefulCount | review_length | review | year | sentiment | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 143975 | Etonogestrel | birth control | 7 | 7-Aug-16 | 4 | 136 | "my experience has been somewhat mixed. i have been using implanon now for nearly 14 months and have decided to get it removed because i bleed every day, all day. i would occasionally stain my underwear and my sheets. it didn't start out that way, for the first month i didn't bleed at all, then i had an epic two week period, then everything was irregular, which has basically been my new norm, sadly. \r\r\n\r\r\ni decided to get rid of the implanon because of the endless bleeding. i should mention that the bleeding was usually pretty light, a bit more than spotting but not quite a period either. other than the endless bleeding, i've been pretty side effect free, except for minor acne.\r\r\n\r\r\ni didn't get pregnant on it, so yeah! but...blood, a lot of blood." | 2016 | 0.110472 |
| 1 | 2 | 106473 | Implanon | birth control | 1 | 11-May-16 | 6 | 140 | "this is my second implanon would not recommend at all....first one was okay for the first 2 years until i started bleeding which never stopped when i woke in the morning i would stand up and be absolutely covered in blood it was that bad.....i lost 2 stone in weight my mood swings were all over the place and it affected my relationship. i was advised to have that one removed and another one inserted which i did which i'm into the second year now and it's starting all over again! the only good thing about this is the reliability that your not going to get pregnant if there's ever a chance that you can have a quick fumble in between periods!! it gets me so down i can be off in the morning and on again at night.....so frustrating" | 2016 | 0.162384 |
| 2 | 6 | 207442 | Suprep Bowel Prep Kit | bowel preparation | 8 | 5-Dec-16 | 18 | 86 | "my prep instructions were one 6oz bottle the evening before and one 6oz bottle the morning of the colonoscopy. both times were similar, started working within 20-25 minutes and lasted a couple hours. i mixed with sprite. the review that mentions salty grape cough syrup was spot on. the first bottle wasn't terrible, the second one almost made me puke. compared to other prep experiences i've heard outside of this site i think suprep is probably one of the easier ones, of course everyone reacts different." | 2016 | -0.109375 |
| 3 | 8 | 140845 | Escitalopram | depression | 9 | 21-Apr-16 | 13 | 49 | "i felt a positive difference within the first week. i also have generalized anxiety and it seems to have helped with it as well. due to my epilepsy, i take the highest dosage that i can, which is 10mg. i feel better but i think 20 would work great." | 2016 | 0.330455 |
| 4 | 9 | 182520 | Mirena | birth control | 1 | 15-Jun-09 | 45 | 37 | "i have been on mirena for over a year now and have experienced some side effects. side effects to watch out for are severe mood swings, hair loss, depression, acne, dizziness, headaches, memory loss, and insomnia. " | 2009 | 0.800000 |
| 5 | 12 | 198830 | Depo-Provera | abnormal uterine bleeding | 2 | 28-Aug-16 | 15 | 64 | "so i've had two shots so far\r\r\n my period has been heavy when i get it and i spot all month long. i've experienced depression in the past and it seems like it's gotten worse on the shot. i've actually attempted suicide since i've started the shot.my sex drive is crap and my mood swings are crazy. i don't recommend this shot to anyone" | 2016 | -0.155556 |
| 6 | 13 | 45707 | Fluoxetine | depression | 1 | 17-Apr-12 | 17 | 84 | "i took prozac for about five months 1989-90. i felt buoyant for the first six weeks, then less so. after three months or so, my mood was down and my fingers were stiff and painful upon waking. after four months, both hands and feet were in pain and did not function for an hour after waking. the condition persisted, in an ever-diminishing form, for five years after discontinuation of the medicine. i am told that my reaction was rare; nevertheless, it happened to me." | 2012 | -0.114418 |
| 7 | 18 | 148611 | Mirena | birth control | 10 | 8-Feb-17 | 40 | 134 | "i love my iud for many reasons. a lot of these reviews are just based off of the initial side effects and insertion. while i admit it was mildly painful for the first 24 hours and the spotting lasted 1-2 months, i am now 3 years in, and couldn't be happier. my period is 95% lighter and lasts only an hour, i never get cramps anymore, and i am comforted by the fact that it is so reliable! no weight gain or mood changes and my skin is still clear. some people say these cause infertility but that is not true. iuds have undergone many many clinical studies which show that is not the case! don't let people on here scare you :) if you want the facts, go to a credible source. http://www.sciencedirect.com/science/article/pii/0010782485900484" | 2017 | 0.208333 |
| 8 | 20 | 208115 | Suprep Bowel Prep Kit | bowel preparation | 8 | 2-Jul-12 | 28 | 66 | "not as bad as i was expecting. the taste is like salty cough syrup, but better than nyquil. the volume to drink wasn't insurmountable. and the effect of the wasn't violent. just know that anything you drink after ingesting the dose will be passed soon afterwards for about then next 4 hours. based on all the reviews of other methods, this seems to be the mildest." | 2012 | -0.225000 |
| 9 | 22 | 178269 | Duloxetine | depression | 8 | 6-Dec-09 | 48 | 126 | "i take 60 mg of cymbalta for depression for the last 5 years and i've felt a noticeable difference in my mood (depression lifted). i used to cry all the time for any little thing, and now my emotions are in check, no more cry baby! there are a few side effects, including out-of-nowhere jerking. it doesn't happen much, but when it does, it's weird! this is a medicine you cannot miss. i have inadvertently missed a dose and was back to the weepies, to the sadness. before i tried cymbalta, i had tried many, many other antidepressants and they never had any effect on my depression. then there was cymbalta. thank goodness for this medicine. i can't imagine my life without it. what a blessing." | 2009 | -0.025000 |
| df_index | patient_id | drugName | condition | rating | date | usefulCount | review_length | review | year | sentiment | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 40364 | 773 | 124603 | Skyla | birth control | 9 | 14-Aug-15 | 6 | 138 | "i got skyla 2 years ago (around $2000 total for 3 years) , and want to get another one the next summer (3 years limit). the insertion of course is never fun, no surgery of any form will be - but i was well enough to enjoy movies that night with friends. my periods have gotten lighter and it's effective in preventing pregnancy. the only grief i have received from the little iud was monthly cramps that i associate with 'my body trying to get rid of it' and sometimes it's so painful i have to curl on the floor, stay still, and sometimes whimper and cry. however, i'm a big girl and it's perhaps twice as painful as my normal menstrual cramping and i'd rather have that once a month than a child i'm not ready for." | 2015 | -0.106250 |
| 40365 | 775 | 54807 | Bupropion / naltrexone | weight loss | 1 | 22-Feb-17 | 15 | 129 | "i've been on contrave for just over 8 weeks now. i never experienced any of the side effects. i also have not lost any weight. i don't feel any differently about food and can't say i feel any less hungry. i am so disappointed and frustrated. today i called contrave to ask about the scale down program. i learned it involves getting a free smart scale. you can keep the scale but after 90 days if you want to keep the "smart" function you have to pay for the service. i also told him that i had not lost any weight and he said this is an "adverse effect" and that he needs to report it as such?? a colleague of mine uses this product and has great success." | 2017 | -0.020304 |
| 40366 | 779 | 85830 | Ethinyl estradiol / norgestimate | birth control | 9 | 7-Nov-13 | 9 | 113 | "i tried bcp in college, but they aggravated my migraines. at age 23, my neurologist said that because most of my migraines occurred just before my period, orthotricylen would work for me. my migraines got better, my already clear complexion become clearer, and my periods lightened. however, the first three months were tough. my breasts swelled from a 34c to a 34d+ (enough to buy a bigger bra), i was easily enraged, and i became a bit of a space cadet - but it all went away after the first 3 months. i also never got pregnant until after taking this pill. if you have migraines, talk to your neurologist about this pill." | 2013 | 0.197778 |
| 40367 | 786 | 31213 | Miconazole | vaginal yeast infection | 1 | 17-Oct-16 | 19 | 129 | "i need you to read my story, as it may one day save your vagina's life!\r\nlast night, whilst wiggle-itching my way through kroger, i decided to purchase miconazole 1.\r\ni made the deposit at 11pm and hit the hay. at 2am, my vagina spontaneously combusted! i tried to wipe/rinse/claw the satan sauce from my vag, to no avail! i even laid spread eagle and quivering in front of a fan . \r\ni finally found some vagisil cooling wipes around 5am, and subsequently passed out.\r\ntoday, my vagina is swollen 4x its natural size...i'm barely walking, but when i do, it's an awkward cowgirl shuffle. i had to use a personal day from work.\r\ni'm applying back to back vagisil treatments, but i'm raw...so incredibly sore, swollen, and raw!" | 2016 | 0.091587 |
| 40368 | 788 | 167113 | Levonorgestrel | birth control | 7 | 8-Jun-16 | 0 | 132 | "well i just got the skyla put in yesterday morning, so far i've been quite crampy but it's a little different than regular period cramps, it's like i can feel the iud in there and maybe it just needs to get situated but i feel like it's not sitting comfortably yet. during my appt. everything was fine although i read a bunch of reviews and psyched myself out, but the doctor explained the process to me and answered my questions. the whole application process was just crampy although one of the applicators opened prematurely right in my cervix which caused a little pain (my doctor said she hadn't ever seen that before) overall, don't let people with low pain tolerances affect your decision about getting skyla. just be prepared for cramps! :)" | 2016 | 0.127282 |
| 40369 | 789 | 73634 | Ethinyl estradiol / norethindrone | birth control | 5 | 8-Jan-13 | 13 | 119 | "my ob/gyn put me on this pill because i have ovarian cysts that rupture causing severe pain and he said the hormones would prevent that from happening. i've been on it for about 2 weeks or so now and my main problem with it is that i get a migrane almost every single day now and i feel nauseous every single day and it gets worse at night. i also experience strong food cravings and certain smells make me feel like puking or thinking about certain foods makes me feel sick to my stomach too. other than that, its great. i guess. i've never been on birth control before so i guess its doing what its supposed to. " | 2013 | 0.044643 |
| 40370 | 792 | 165612 | Levonorgestrel | emergency contraception | 10 | 26-Apr-17 | 8 | 101 | "i had sex for the first time on april 10th. we didn't use protection, it was kinda in the moment so we didn't think about it. he didn't cum inside of me but he had cum before earlier in the night. i was terrifed that i might have gotten pregnant from the precum. especially since i was supposed to be ovulating. i took a plan b 10 hours later. i got nausea, cramps, backaches, headaches, acne, the works. i thought i was pregnant but it was just the side effects. my period came a day late, i started today, april 26th." | 2017 | 0.088095 |
| 40371 | 794 | 148683 | Mirena | birth control | 9 | 24-Sep-16 | 5 | 132 | "switched from combination pill to mirena after 5 years on the pill. i'm 27 and have never been pregnant.\r\r\nthe insertion was. the worst thing i've ever experienced ! almost fainted. the following 8 hours i had really bad cramps (never really had them before), i'd say a 8/10. also threw up six times and got diarrhoea. strange! the following 5 days light spotting, then light period (as planned) for about a week. \r\r\nit's now been almost 8 weeks since insertion, got my second period which was very light compared to being on the pill. apart from the horrible insertion i'm very content with mirena, absolutely worth it! also much cheaper as my pill cost around $10 each month and the mirena only $70 for five years, perk of living in sweden." | 2016 | 0.033284 |
| 40372 | 796 | 138772 | Phentermine | weight loss | 10 | 7-Sep-12 | 55 | 78 | "after suffering from bulimia for many years and not being able to control my binge eating i started taking fastin. i only take 1 1/2 pills a day (i'm only 115 lbs and not looking for significant weight loss) and that is enough to help me fight my urge to stress eat. in fact when i was taking 2 pills a day i found myself forgetting to eat. i still feel a little jittery after taking them. " | 2012 | 0.169643 |
| 40373 | 797 | 113023 | Bisacodyl | constipation | 4 | 21-Oct-16 | 12 | 94 | "well i took this to help get the pipes moving when they hadn't for a few days on a camping trip. first night back at home and i took of them with a lot of water at 11:30 pm. within 2 hours the gi cramping started, and continued and got progressively worse, sweats, nausea. the pipes moving sound loud rumbles started at about 4 am and continued through about 5 pm. it was awful.. awful. colonoscopy prep was better. i don't think i'll use this product again. i would not reccomend this to anyone." | 2016 | -0.150000 |